Whole Database

Seat Data

{% for party, seats in seats.items() %}

{{ party }} {{ seats }}

{% endfor %}

Candidates

{% for candidate in candidates %}

{{candidate.candidate_id}} {{ candidate.firstname }} {{ candidate.surname }} {{ candidate.gender }} {{ candidate.sitting_mp }} {{ candidate.party_id }} {{ candidate.constituency_id }}

{% endfor %}

Constituencies

{% for constituency in constituencies %}

{{ constituency.constituency_id }} {{ constituency.constituency_name }} {{ constituency.county_name }} {{ constituency.region_name }} {{ constituency.country_name }} {{ constituency.constituency_type }}

{% endfor %}

Parties

{% for party in parties %}

{{ party.party_id }} {{party.party_name}}

{% endfor %}

Votes

{% for vote in votes %}

{{ vote.vote_id }} {{ vote.constituency_id }} {{ vote.party_id }} {{ vote.candidate_id }} {{ vote.votes }}

{% endfor %}

Results

{% for result in results %} {% endfor %}
System Party Seat Allocation Percentage of Seats Percentage of Popular Votes Difference Percentage Winning Party Different From Actual Winner
{{ result.system1 }} {{ result.party }} {{ result.seat_allocation }} {{ result.percentage_of_seats }}% {{ result.percentage_of_popular_votes }}% {{ result.difference_percentage }}% {{ result.winning_party }} {{ result.different_from_actual_winner }}